Nebula 2/Nebula Two.iso/NextAnswers/UniqueKey_sybase/installPEOPLE.sqlsybase

Text File | 1994-06-30 | 52KB | 1,960 lines

/******************************************************************************
* Create the PEOPLE database by pasting this file into an isql terminal window.
******************************************************************************/
use master
go
drop database PEOPLE
go

create database PEOPLE
go
use PEOPLE
go

/******************************************************************************
* Cut below this banner to just drop the tables.
*
* If you do elect to do this and do not drop the database, dump tran insures
* that your transaction log will not fill up.  Dump tran is not generally used
* unless the database has been backed up by a dump, but we include it here
* since this is only an example and the data is restored in this file.
******************************************************************************/
dump tran PEOPLE with no_log
go
drop table EMPLOYEE
go
drop table DEPARTMENT
go
drop table FACILITY
go
drop table EMP_PROJECT
go
drop table PROJECT
go
drop table EMP_PHOTO
go
drop table EMP_QUOTE
go
drop table JOB_TITLE
go
drop table EMP_EQUIPMENT
go
drop table UNIQUE_KEY
go


/******************************************************************************
*  Create the tables.
******************************************************************************/
create table EMPLOYEE (
EMP_ID int,
DEPT_ID int null,
LAST_NAME varchar(40),
FIRST_NAME varchar(40),
PHONE char(12) null,
ADDRESS varchar(40) null,
CITY varchar(20) null,
STATE char(2) null,
ZIP char(5) null,
TITLE_ID int null,
HIRE_DATE datetime null,
MANAGER int null,
SALARY float null
)
go

create table DEPARTMENT (
DEPT_ID int,
DEPARTMENT_NAME varchar(30),
LOCATION_ID int
)
go

create table FACILITY (
LOCATION_ID int,
LOCATION varchar(30),
PHOTO image null
)
go

create table EMP_PROJECT (
EMP_ID int,
PROJECT_ID int,
)
go

create table PROJECT (
PROJECT_ID int,
PROJECT_NAME varchar(30),
SUMMARY_IMAGE image null
)
go

create table EMP_PHOTO (
EMP_ID int,
PHOTO image null
)
go

create table EMP_QUOTE (
EMP_ID int,
QUOTE image null
)
go

create table JOB_TITLE (
TITLE_ID int,
TITLE varchar(30),
TITLE_TYPE varchar(12)
)
go

create table EMP_EQUIPMENT (
ASSET_TAG int,
DESCRIPTION varchar(100) null,
SERIAL_NUMBER varchar(20) null,
EMP_ID int null
)
go


/******************************************************************************
*  Insert values.
******************************************************************************/
begin transaction
go

insert into  FACILITY values(1101, 'Waterfront One', null)
go

insert into  FACILITY values(1103, 'Hillside 1', null)
go

insert into  FACILITY values(1106, 'Hillside 2', null)
go

insert into  FACILITY values(1207, 'Embarcadero', null)
go

insert into  FACILITY values(1104, 'Arcada', null)
go

insert into EMP_PROJECT values (101, 501)
go

insert into EMP_PROJECT values (102, 503)
go

insert into EMP_PROJECT values (103, 507)
go

insert into EMP_PROJECT values (104, 510)
go

insert into EMP_PROJECT values (105, 512)
go

insert into EMP_PROJECT values (106, 501)
go

insert into EMP_PROJECT values (107, 503)
go

insert into EMP_PROJECT values (108, 507)
go

insert into EMP_PROJECT values (109, 510)
go

insert into EMP_PROJECT values (110, 512)
go

insert into EMP_PROJECT values (111, 501)
go

insert into EMP_PROJECT values (112, 503)
go

insert into EMP_PROJECT values (113, 507)
go

insert into EMP_PROJECT values (114, 510)
go

insert into EMP_PROJECT values (115, 512)
go

insert into EMP_PROJECT values (116, 501)
go

insert into EMP_PROJECT values (117, 503)
go

insert into EMP_PROJECT values (118, 507)
go

insert into EMP_PROJECT values (119, 510)
go

insert into EMP_PROJECT values (120, 512)
go

insert into EMP_PROJECT values (121, 501)
go

insert into EMP_PROJECT values (122, 503)
go

insert into EMP_PROJECT values (123, 507)
go

insert into EMP_PROJECT values (124, 510)
go

insert into EMP_PROJECT values (125, 512)
go

insert into EMP_PROJECT values (126, 501)
go

insert into EMP_PROJECT values (127, 503)
go

insert into EMP_PROJECT values (128, 507)
go

insert into EMP_PROJECT values (129, 510)
go

insert into EMP_PROJECT values (130, 512)
go

insert into EMP_PROJECT values (131, 501)
go

insert into EMP_PROJECT values (132, 503)
go

insert into EMP_PROJECT values (133, 507)
go

insert into EMP_PROJECT values (134, 510)
go

insert into EMP_PROJECT values (135, 512)
go

insert into EMP_PROJECT values (136, 501)
go

insert into EMP_PROJECT values (137, 503)
go

insert into EMP_PROJECT values (138, 507)
go

insert into EMP_PROJECT values (139, 510)
go

insert into EMP_PROJECT values (140, 512)
go

insert into EMP_PROJECT values (141, 501)
go

insert into EMP_PROJECT values (142, 503)
go

insert into EMP_PROJECT values (143, 507)
go

insert into EMP_PROJECT values (144, 510)
go

insert into EMP_PROJECT values (145, 512)
go

insert into EMP_PROJECT values (146, 501)
go

insert into EMP_PROJECT values (147, 503)
go

insert into EMP_PROJECT values (148, 507)
go

insert into EMP_PROJECT values (149, 510)
go

insert into EMP_PROJECT values (150, 512)
go

insert into EMP_PROJECT values (151, 501)
go

insert into EMP_PROJECT values (152, 503)
go

insert into EMP_PROJECT values (153, 507)
go

insert into EMP_PROJECT values (154, 510)
go

insert into EMP_PROJECT values (155, 512)
go

insert into EMP_PROJECT values (156, 501)
go

insert into EMP_PROJECT values (157, 503)
go

insert into EMP_PROJECT values (158, 507)
go

insert into EMP_PROJECT values (159, 510)
go

insert into EMP_PROJECT values (160, 512)
go

insert into EMP_PROJECT values (161, 501)
go

insert into EMP_PROJECT values (162, 503)
go

insert into EMP_PROJECT values (163, 507)
go

insert into EMP_PROJECT values (164, 510)
go

insert into EMP_PROJECT values (165, 512)
go

insert into EMP_PROJECT values (166, 501)
go

insert into EMP_PROJECT values (167, 503)
go

insert into EMP_PROJECT values (168, 507)
go

insert into EMP_PROJECT values (169, 510)
go

insert into EMP_PROJECT values (170, 512)
go

insert into EMP_PROJECT values (171, 501)
go

insert into EMP_PROJECT values (172, 503)
go

insert into EMP_PROJECT values (173, 507)
go

insert into EMP_PROJECT values (174, 510)
go

insert into EMP_PROJECT values (175, 512)
go

insert into EMP_PROJECT values (176, 501)
go

insert into EMP_PROJECT values (177, 503)
go

insert into EMP_PROJECT values (178, 507)
go

insert into EMP_PROJECT values (179, 510)
go

insert into EMP_PROJECT values (180, 512)
go

insert into EMP_PROJECT values (181, 501)
go

insert into EMP_PROJECT values (182, 503)
go

insert into EMP_PROJECT values (183, 507)
go

insert into EMP_PROJECT values (184, 510)
go

insert into EMP_PROJECT values (185, 512)
go

insert into EMP_PROJECT values (186, 501)
go

insert into EMP_PROJECT values (187, 503)
go

insert into EMP_PROJECT values (188, 507)
go

insert into EMP_PROJECT values (189, 510)
go

insert into EMP_PROJECT values (190, 512)
go

insert into EMP_PROJECT values (191, 501)
go

insert into EMP_PROJECT values (192, 503)
go

insert into EMP_PROJECT values (193, 507)
go

insert into EMP_PROJECT values (194, 510)
go

insert into EMP_PROJECT values (195, 512)
go

insert into EMP_PROJECT values (196, 501)
go

insert into EMP_PROJECT values (197, 503)
go

insert into EMP_PROJECT values (198, 507)
go

insert into EMP_PROJECT values (199, 510)
go

insert into EMP_PROJECT values (200, 512)
go

insert into EMP_PROJECT values (201, 501)
go

insert into EMP_PROJECT values (202, 503)
go

insert into EMP_PROJECT values (203, 507)
go

insert into EMP_PROJECT values (204, 510)
go

insert into EMP_PROJECT values (205, 512)
go

insert into EMP_PROJECT values (206, 501)
go

insert into EMP_PROJECT values (207, 503)
go

insert into EMP_PROJECT values (208, 507)
go

insert into EMP_PROJECT values (209, 510)
go

insert into EMP_PROJECT values (210, 512)
go

insert into EMP_PROJECT values (211, 501)
go

insert into EMP_PROJECT values (212, 503)
go

insert into EMP_PROJECT values (213, 507)
go

insert into EMP_PROJECT values (214, 510)
go

insert into EMP_PROJECT values (215, 512)
go

insert into EMP_PROJECT values (216, 501)
go

insert into EMP_PROJECT values (217, 503)
go

insert into EMP_PROJECT values (218, 507)
go

insert into EMP_PROJECT values (219, 510)
go

insert into EMP_PROJECT values (220, 512)
go

insert into EMP_PROJECT values (221, 501)
go

insert into EMP_PROJECT values (222, 503)
go

insert into EMP_PROJECT values (223, 507)
go

insert into EMP_PROJECT values (224, 510)
go

insert into EMP_PROJECT values (225, 512)
go


insert into PROJECT values( 501, 'BankLink Financials', null)
go

insert into PROJECT values( 503, 'Crossover Environment', null)
go

insert into PROJECT values( 507, 'Net DesignWorks', null)
go

insert into PROJECT values( 510, 'InfoVault', null)
go

insert into PROJECT values( 512, 'Customer Satisfaction', null)
go


insert into  DEPARTMENT values (100, 'General and Administration', 1104)
go

insert into  DEPARTMENT values (101, 'Office of the President', 1207)
go

insert into  DEPARTMENT values (104, 'Reception', 1104)
go

insert into  DEPARTMENT values (105, 'Adminstration', 1103)
go

insert into  DEPARTMENT values (200, 'Production and Design', 1103)
go

insert into  DEPARTMENT values (201, 'Art Design', 1104)
go

insert into  DEPARTMENT values (202, 'Hardware Engineering', 1106)
go

insert into  DEPARTMENT values (203, 'System Software', 1106)
go

insert into  DEPARTMENT values (204, 'User Software', 1101)
go

insert into  DEPARTMENT values (250, 'Production', 1106)
go

insert into  DEPARTMENT values (252, 'Logistics', 1101)
go

insert into  DEPARTMENT values (300, 'Sales and Marketing', 1207)
go

insert into  DEPARTMENT values (320, 'Domestic Marketing', 1207)
go

insert into  DEPARTMENT values (330, 'International Marketing', 1207)
go

insert into  DEPARTMENT values (350, 'Sales', 1207)
go

insert into  DEPARTMENT values (400, 'Customer Service', 1106)
go

insert into  DEPARTMENT values (405, 'Service Logistics', 1106)
go

insert into  DEPARTMENT values (410, 'Customer Front-Line', 1106)
go

insert into  DEPARTMENT values (420, 'Customer Back-Line', 1106)
go

insert into  DEPARTMENT values (500, 'Personnel', 1101)
go

insert into  DEPARTMENT values (900, 'Public Relations', 1104)
go


insert into JOB_TITLE values (1, 'President', 'Salaried')
go

insert into JOB_TITLE values (2, 'Vice President', 'Salaried')
go

insert into JOB_TITLE values (3, 'Director', 'Salaried')
go

insert into JOB_TITLE values (4, 'MANAGER', 'Salaried')
go

insert into JOB_TITLE values (5, 'Engineer', 'Hourly')
go

insert into JOB_TITLE values (6, 'Designer', 'Hourly')
go

insert into JOB_TITLE values (7, 'Sales Representative', 'Salaried')
go

insert into JOB_TITLE values (8, 'Administrator', 'Hourly')
go

insert into JOB_TITLE values (9, 'Customer Representative', 'Hourly')
go

insert into JOB_TITLE values (10, 'Product MANAGER', 'Salaried')
go

insert into JOB_TITLE values (11, 'Benefits and Compensation', 'Hourly')
go

insert into JOB_TITLE values (12, 'Associate', 'Hourly')
go


insert into EMPLOYEE values ( 101, 101, 'Winston', 'James', '415-323-7265',
 '6269 Washington Ave.', 'Woodside', 'CA', '94160', 1,
 'Jan 14 1989 12:00:00:000AM', 101, 5700.00 )

go

insert into EMPLOYEE values ( 102, 200, 'Veasey', 'Kai', '415-323-261 ',
 '3401 Strand St.', 'Woodside', 'CA', '94153', 2,
 'Aug 19 1991 12:00:00:000AM', 1, 4600.00 )

go

insert into EMPLOYEE values ( 103, 400, 'MacAskill', 'Debra', '415-328-4407',
 '3495 Middlefield Ave.', 'Mountain View', 'CA', '94245', 2,
 'Nov 19 1992 12:00:00:000AM', 101, 4300.00 )

go

insert into EMPLOYEE values ( 104, 104, 'Oswald', 'Lesley', '415-321-564 ',
 '6751 Chowen St.', 'Sunnyvale', 'CA', '94234', 4,
 'Jun 20 1994 12:00:00:000AM', 101, 4200.00 )

go

insert into EMPLOYEE values ( 105, 320,'Scheer', 'Janine', '415-327-9345',
 '295 Poplar Road', 'San Jose', 'CA', '94226', 4,
 'Jan  5 1990 12:00:00:000AM', 107, 5700.00 )

go

insert into EMPLOYEE values ( 106, 500, 'Maselli', 'John', '415-328-9769',
 '3494 Pelican Ave.', 'Palo Alto', 'CA', '94226', 2,
 'Apr 16 1992 12:00:00:000AM', 101, 4900.00 )

go

insert into EMPLOYEE values ( 107, 300, 'Lunau', 'Ken', '415-322-2815',
 '7163 York Road', 'Woodside', 'CA', '94174', 2,
 'Dec 12 1991 12:00:00:000AM', 101, 5600.00 )

go

insert into EMPLOYEE values ( 108, 203, 'DeKeyser', 'John', '415-326-9241',
 '5633 High Road', 'Mountain View', 'CA', '94228', 3,
 'Nov 18 1989 12:00:00:000AM', 102, 5200.00 )

go

insert into EMPLOYEE values ( 109, 900, 'Windgate', 'Mark', '415-321-3718',
 '4615 Oak Ave.', 'Oakland', 'CA', '94194', 2,
 'Feb 20 1990 12:00:00:000AM', 101, 4000.00 )

go

insert into EMPLOYEE values ( 110, 400,'Walsh', 'Phyllis', '415-327-2599',
 '3746 Oak Road', 'Palo Alto', 'CA', '94165', 5,
 'Aug 14 1991 12:00:00:000AM', 103, 4900.00 )

go


insert into EMPLOYEE values ( 111, 203, 'Quan', 'Merianne', '415-323-9827',
 '7503 Washington Blvd.', 'Redwood City', 'CA', '94223', 5,
 'Apr  6 1988 12:00:00:000AM', 102, 4700.00 )

go

insert into EMPLOYEE values ( 112, 300, 'Kanzaki', 'Mark', '415-324-7911',
 '2709 Kristen St.', 'Woodside', 'CA', '94219', 3,
 'Apr  5 1988 12:00:00:000AM', 107, 4500.00 )
go

insert into EMPLOYEE values ( 113, 400, 'Helton', 'Dung', '415-320-6474',
 '4397 Schoman Road', 'Woodside', 'CA', '94173', 5,
 'Oct  9 1990 12:00:00:000AM', 103, 5600.00 )

go

insert into EMPLOYEE values ( 114, 200, 'Thiry', 'Greg', '415-326-4613',
 '3883 Drew Road', 'Redwood City', 'CA', '94198', 10,
 'Mar 13 1988 12:00:00:000AM', 102, 4700.00 )

go

insert into EMPLOYEE values ( 115, 400,'Gath', 'Jon', '415-322-1987',
 '502 Johnson St.', 'Santa Clara', 'CA', '94209', 5,
 'Nov  4 1989 12:00:00:000AM', 103, 5100.00 )

go

insert into EMPLOYEE values ( 116, 203, 'Kallimani', 'Yoshinori', '415-322-6335',
 '7099 Knuth Ave.', 'San Jose', 'CA', '94214', 3,
 'Dec 26 1990 12:00:00:000AM', 102, 4200.00 )

go

insert into EMPLOYEE values ( 117, 405, 'Hojnowski', 'Gregor', '415-323-2994',
 '5215 Strand Way', 'Pacific Heights', 'CA', '94209', 5,
 'Oct 25 1992 12:00:00:000AM', 103, 5200.00 )

go

insert into EMPLOYEE values ( 118, 300, 'Tautz', 'Denise', '415-322-3937',
 '7851 Oak Trail', 'Woodside', 'CA', '94181', 10,
 'Mar  3 1992 12:00:00:000AM', 107, 5100.00 )

go

insert into EMPLOYEE values ( 119, 500, 'Upson', 'Alex', '415-323-11  ',
 '1440 Addams Circle', 'Mountain View', 'CA', '94193', 4,
 'Sep  9 1989 12:00:00:000AM', 106, 4900.00 )

go

insert into EMPLOYEE values ( 120, 350,'Riley', 'Michael', '415-323-2795',
 '7747 Pope Road', 'Redwood City', 'CA', '94195', 7,
 'Feb  3 1991 12:00:00:000AM', 107, 4300.00 )

go


insert into EMPLOYEE values ( 121, 252, 'Kammerer', 'Sanjay', '415-328-3042',
 '7331 Walnut Ave.', 'Palo Alto', 'CA', '94178', 5,
 'Jan  9 1990 12:00:00:000AM', 102, 4700.00 )

go

insert into EMPLOYEE values ( 122, 405, 'Affinito', 'Jon', '415-326-515 ',
 '639 Schoman Ave.', 'Woodside', 'CA', '94239', 5,
 'May  1 1988 12:00:00:000AM', 103, 5000.00 )

go

insert into EMPLOYEE values ( 123, 400, 'Liu', 'Tom', '415-321-1766',
 '3342 Main St.', 'Sunnyvale', 'CA', '94219', 5,
 'Jan  6 1989 12:00:00:000AM', 103, 4700.00 )

go

insert into EMPLOYEE values ( 124, 410, 'Walton', 'Jennifer', '415-324-4697',
 '2673 France St.', 'Santa Clara', 'CA', '94157', 4,
 'Jan 18 1990 12:00:00:000AM', 103, 5700.00 )

go
insert into EMPLOYEE values ( 125, 101,'Page', 'Paul', '415-320-8100',
 '2754 Johnson Ave.', 'Redwood City', 'CA', '94170', 4,
 'Aug 18 1992 12:00:00:000AM', 101, 4200.00 )

go

insert into EMPLOYEE values ( 126, 105, 'Seng', 'Paul', '415-320-7249',
 '4876 High Road', 'Half Moon Bay', 'CA', '94171', 6,
 'Jul  2 1988 12:00:00:000AM', 101, 5000.00 )

go

insert into EMPLOYEE values ( 127, 101, 'Nelson', 'Andrew', '415-323-1072',
 '562 Knuth Circle', 'Palo Alto', 'CA', '94164', 11,
 'Nov 14 1988 12:00:00:000AM', 101, 5300.00 )

go

insert into EMPLOYEE values ( 128, 252, 'Tucker', 'Karen', '415-323-1180',
 '1952 Lutece St.', 'Atherton', 'CA', '94195', 5,
 'Nov 12 1989 12:00:00:000AM', 102, 5700.00 )

go

insert into EMPLOYEE values ( 129, 410, 'Tavana', 'Jim', '415-321-4763',
 '7067 Broad Road', 'Woodside', 'CA', '94236', 4,
 'May  5 1992 12:00:00:000AM', 103, 5500.00 )

go

insert into EMPLOYEE values ( 130, 250,'Paquette', 'Satch', '415-326-4537',
 '6972 York Road', 'Pacific Heights', 'CA', '94158', 5,
 'Apr 27 1992 12:00:00:000AM', 102, 4800.00 )

go

insert into EMPLOYEE values ( 131, 350, 'Egner', 'Andy', '415-322-8602',
 '4106 Poplar St.', 'Redwood City', 'CA', '94246', 7,
 'Sep  3 1990 12:00:00:000AM', 107, 5700.00 )

go

insert into EMPLOYEE values ( 132, 104, 'Page', 'Opal', '415-323-4670',
 '859 Poplar St.', 'Redwood City', 'CA', '94218', 6,
 'Mar 27 1989 12:00:00:000AM', 101, 5300.00 )

go

insert into EMPLOYEE values ( 133, 203, 'Bay', 'Rosalie', '415-320-3763',
 '6535 Juneberry Ave.', 'Mountain View', 'CA', '94243', 4,
 'Feb  5 1992 12:00:00:000AM', 102, 4300.00 )

go

insert into EMPLOYEE values ( 134, 300, 'Fisk', 'George', '415-326-4655',
 '4346 Connell Circle', 'Atherton', 'CA', '94211', 3,
 'May  1 1991 12:00:00:000AM', 107, 5700.00 )

go

insert into EMPLOYEE values ( 135, 252,'Hecker', 'Junko', '415-321-7489',
 '3930 York Ave.', 'Redwood City', 'CA', '94178', 5,
 'Jan 24 1988 12:00:00:000AM', 102, 4700.00 )

go

insert into EMPLOYEE values ( 136, 101, 'Walsh', 'Guiseppe', '415-328-2963',
 '1209 High Road', 'Atherton', 'CA', '94172', 10,
 'Nov 28 1992 12:00:00:000AM', 101, 4200.00 )

go

insert into EMPLOYEE values ( 137, 105, 'Davidson', 'Cary', '415-322-7699',
 '4773 York St.', 'Santa Clara', 'CA', '94160', 3,
 'May 23 1989 12:00:00:000AM', 101, 5600.00 )

go

insert into EMPLOYEE values ( 138, 250, 'Burt', 'Elida', '415-324-444 ',
 '939 Middlefield St.', 'Santa Clara', 'CA', '94232', 5,
 'Apr  6 1988 12:00:00:000AM', 102, 4500.00 )

go

insert into EMPLOYEE values ( 139, 900, 'Kelleher', 'Leonard', '415-328-569 ',
 '3481 Knox St.', 'Palo Alto', 'CA', '94246', 12,
 'Jul 27 1990 12:00:00:000AM', 109, 4600.00 )

go

insert into EMPLOYEE values ( 140, 203,'Henriquez', 'Dave', '415-320-6936',
 '3790 Market Road', 'Belmont', 'CA', '94219', 5,
 'Oct 10 1992 12:00:00:000AM', 102, 5700.00 )

go


insert into EMPLOYEE values ( 141, 252, 'Fuster', 'Manny', '415-325-3468',
 '6688 Poplar Blvd.', 'Millbrae', 'CA', '94187', 4,
 'Dec 15 1990 12:00:00:000AM', 102, 5100.00 )

go

insert into EMPLOYEE values ( 142, 104, 'Cleary', 'Kathi', '415-320-3912',
 '2746 Schoman St.', 'Redwood City', 'CA', '94150', 11,
 'Nov 23 1991 12:00:00:000AM', 101, 5100.00 )

go

insert into EMPLOYEE values ( 143, 350, 'Moore', 'Debra', '415-326-5087',
 '4126 Lutece Ave.', 'San Jose', 'CA', '94237', 7,
 'Apr  4 1991 12:00:00:000AM', 107, 5000.00 )

go

insert into EMPLOYEE values ( 144, 100, 'Hopkins', 'Chris', '415-321-8620',
 '1482 Elm Ave.', 'Oakland', 'CA', '94198', 7,
 'Aug 13 1991 12:00:00:000AM', 101, 5300.00 )

go

insert into EMPLOYEE values ( 145, 204,'Self', 'Jack', '415-325-767 ',
 '7044 Walnut Road', 'Half Moon Bay', 'CA', '94164', 4,
 'Nov  5 1990 12:00:00:000AM', 102, 5500.00 )

go

insert into EMPLOYEE values ( 146, 500, 'Cerbone', 'Mark', '415-322-2943',
 '7137 Juneberry Road', 'San Francisco', 'CA', '94172', 3,
 'May 13 1991 12:00:00:000AM', 106, 4300.00 )

go

insert into EMPLOYEE values ( 147, 202, 'Ralston', 'Anne', '415-323-4177',
 '3599 Beech Ave.', 'Palo Alto', 'CA', '94169', 5,
 'Jul 20 1991 12:00:00:000AM', 102, 5000.00 )

go

insert into EMPLOYEE values ( 148, 250, 'Henry', 'John', '415-322-5562',
 '7645 Lancaster Ave.', 'Belmont', 'CA', '94231', 5,
 'Jan 14 1991 12:00:00:000AM', 102, 4500.00 )

go

insert into EMPLOYEE values ( 149, 200, 'Kinney', 'Alex', '415-327-8472',
 '4044 Hanson St.', 'Mountain View', 'CA', '94239', 6,
 'Sep 24 1990 12:00:00:000AM', 102, 5300.00 )

go

insert into EMPLOYEE values ( 150, 420,'Moore', 'James', '415-325-4316',
 '6425 Broad Ave.', 'Redwood City', 'CA', '94244', 5,
 'Aug 23 1989 12:00:00:000AM', 103, 5600.00 )

go


insert into EMPLOYEE values ( 151, 105, 'Nguyen', 'Jorg', '415-322-2523',
 '5531 Knuth St.', 'Pacific Heights', 'CA', '94192', 11,
 'Feb 27 1990 12:00:00:000AM', 101, 5600.00 )

go

insert into EMPLOYEE values ( 152, 330, 'Veasey', 'David', '415-320-1483',
 '3999 Juneberry Road', 'Belmont', 'CA', '94177', 10,
 'Dec  8 1992 12:00:00:000AM', 107, 4400.00 )

go

insert into EMPLOYEE values ( 153, 350, 'Morse', 'Guy', '415-328-6708',
 '1276 Middlefield Ave.', 'Atherton', 'CA', '94234', 7,
 'Apr  4 1991 12:00:00:000AM', 107, 4000.00 )

go

insert into EMPLOYEE values ( 154, 350, 'Fordam', 'Donna', '415-320-2744',
 '7712 Chowen St.', 'Oakland', 'CA', '94215', 7,
 'Mar 21 1990 12:00:00:000AM', 107, 4800.00 )

go

insert into EMPLOYEE values ( 155, 320,'Walsh', 'James', '415-323-7264',
 '3532 Anderson St.', 'San Francisco', 'CA', '94179', 10,
 'Aug 23 1990 12:00:00:000AM', 107, 4200.00 )

go

insert into EMPLOYEE values ( 156, 420, 'Fukasawa', 'Ben', '415-327-4471',
 '5337 Kristen Blvd.', 'Palo Alto', 'CA', '94207', 5,
 'Sep 23 1989 12:00:00:000AM', 103, 4300.00 )

go

insert into EMPLOYEE values ( 157, 200, 'Yu', 'Martin', '415-321-9787',
 '7580 High Ave.', 'Palo Alto', 'CA', '94186', 3,
 'Dec 26 1991 12:00:00:000AM', 102, 4800.00 )

go

insert into EMPLOYEE values ( 158, 201, 'Hodor', 'Lee', '415-328-151 ',
 '2669 Sparrow Ave.', 'Belmont', 'CA', '94194', 6,
 'Feb 22 1988 12:00:00:000AM', 102, 4000.00 )

go

insert into EMPLOYEE values ( 159, 203, 'Naroff', 'Unjieng,', '415-322-8693',
 '5176 Lincoln St.', 'San Francisco', 'CA', '94168', 5,
 'Jan  5 1990 12:00:00:000AM', 102, 5300.00 )

go

insert into EMPLOYEE values ( 160, 330,'Lee', 'Eric', '415-326-9238',
 '3234 Connell St.', 'San Francisco', 'CA', '94198', 3,
 'Jan 22 1989 12:00:00:000AM', 107, 4900.00 )

go

insert into EMPLOYEE values ( 161, 330, 'Barber', 'Bart', '415-320-7854',
 '7277 Shorebird St.', 'Half Moon Bay', 'CA', '94243', 10,
 'Jul 18 1991 12:00:00:000AM', 107, 4200.00 )

go

insert into EMPLOYEE values ( 162, 900, 'Patel', 'Jim', '415-322-3915',
 '2767 Drew St.', 'Sunnyvale', 'CA', '94214', 12,
 'Jul 12 1992 12:00:00:000AM', 109, 5400.00 )

go

insert into EMPLOYEE values ( 163, 900, 'Vergnot', 'Glenn', '415-324-287 ',
 '6882 Connell St.', 'San Francisco', 'CA', '94236', 3,
 'Aug 18 1991 12:00:00:000AM', 109, 4300.00 )

go

insert into EMPLOYEE values ( 164, 104, 'Hertz', 'Christian', '415-321-3157',
 '1884 Pope St.', 'San Jose', 'CA', '94208', 3,
 'Oct 12 1989 12:00:00:000AM', 101, 4000.00 )

go

insert into EMPLOYEE values ( 165, 350,'Etcheverry', 'Jon', '415-328-714 ',
 '2996 Lutece St.', 'Belmont', 'CA', '94216', 7,
 'Feb 21 1988 12:00:00:000AM', 107, 4200.00 )

go

insert into EMPLOYEE values ( 166, 101, 'Burt', 'Alice', '415-320-3192',
 '5114 Lancaster St.', 'Pacific Heights', 'CA', '94241', 3,
 'Oct 14 1992 12:00:00:000AM', 101, 5200.00 )

go

insert into EMPLOYEE values ( 167, 350, 'Novak', 'Russ', '415-326-281 ',
 '6478 Spruce Trail', 'Mountain View', 'CA', '94185', 7,
 'Apr 13 1989 12:00:00:000AM', 107, 4900.00 )

go

insert into EMPLOYEE values ( 168, 202, 'Francis', 'Vicki', '415-321-8842',
 '2391 Broadway Ave.', 'Redwood City', 'CA', '94220', 5,
 'Jul 24 1991 12:00:00:000AM', 102, 4200.00 )

go

insert into EMPLOYEE values ( 169, 201, 'Jochims', 'Hal', '415-324-8628',
 '6030 State Ave.', 'Palo Alto', 'CA', '94217', 6,
 'Jul 21 1992 12:00:00:000AM', 102, 4200.00 )

go

insert into EMPLOYEE values ( 170, 900,'Tucker', 'Tom', '415-328-2067',
 '3258 Wallace St.', 'Mountain View', 'CA', '94246', 12,
 'Mar 18 1988 12:00:00:000AM', 109, 4600.00 )

go


insert into EMPLOYEE values ( 171, 252, 'Herald', 'Ellen', '415-321-1238',
 '674 Addams Road', 'San Francisco', 'CA', '94228', 5,
 'Feb  5 1990 12:00:00:000AM', 102, 5300.00 )

go

insert into EMPLOYEE values ( 172, 405, 'Anthony', 'Mitch', '415-322-3205',
 '5062 Hanson Trail', 'Half Moon Bay', 'CA', '94218', 5,
 'May 26 1991 12:00:00:000AM', 103, 4600.00 )

go

insert into EMPLOYEE values ( 173, 350, 'Fuster', 'Lane', '415-320-9534',
 '7796 Main Ave.', 'Sunnyvale', 'CA', '94163', 7,
 'Jan 25 1988 12:00:00:000AM', 107, 4300.00 )

go

insert into EMPLOYEE values ( 174, 350, 'Dunham', 'Jim', '415-320-691 ',
 '3866 Lancaster St.', 'Mountain View', 'CA', '94190', 7,
 'Jul  9 1988 12:00:00:000AM', 107, 4700.00 )

go

insert into EMPLOYEE values ( 175, 300,'Ferrante', 'Kristen', '415-324-6344',
 '6086 Broad Blvd.', 'Sunnyvale', 'CA', '94216', 4,
 'Apr 14 1990 12:00:00:000AM', 107, 5100.00 )

go

insert into EMPLOYEE values ( 176, 202, 'Manross', 'Ken', '415-325-8979',
 '2452 Lincoln Blvd.', 'Pacific Heights', 'CA', '94228', 5,
 'Feb 18 1988 12:00:00:000AM', 102, 5600.00 )

go

insert into EMPLOYEE values ( 177, 105, 'Dahlbeck', 'Olivier', '415-326-2780',
 '3510 Wallace Trail', 'Millbrae', 'CA', '94187', 5,
 'Mar 12 1988 12:00:00:000AM', 101, 4600.00 )

go

insert into EMPLOYEE values ( 178, 400, 'Meyer', 'Bonnie', '415-324-140 ',
 '1885 Kristen St.', 'Belmont', 'CA', '94155', 5,
 'Jan 14 1991 12:00:00:000AM', 103, 4900.00 )

go

insert into EMPLOYEE values ( 179, 203, 'Lappin', 'Denise', '415-320-2072',
 '6441 Spruce St.', 'Palo Alto', 'CA', '94198', 5,
 'May 20 1992 12:00:00:000AM', 102, 5200.00 )

go

insert into EMPLOYEE values ( 180, 100,'Magennis', 'Jerry', '415-320-3085',
 '2457 Chowen St.', 'Redwood City', 'CA', '94224', 8,
 'Dec 28 1989 12:00:00:000AM', 101, 4300.00 )

go


insert into EMPLOYEE values ( 181, 202, 'Law', 'Mike', '415-320-4077',
 '1683 Roberts Blvd.', 'Oakland', 'CA', '94174', 5,
 'Jul 13 1990 12:00:00:000AM', 102, 4700.00 )

go

insert into EMPLOYEE values ( 182, 350, 'Jackson', 'Thomas', '415-320-5390',
 '3279 Hanson St.', 'Belmont', 'CA', '94177', 7,
 'Jun  8 1991 12:00:00:000AM', 107, 5300.00 )

go

insert into EMPLOYEE values ( 183, 320, 'Rokovich', 'Dung', '415-320-7176',
 '4656 Anderson St.', 'Palo Alto', 'CA', '94210', 10,
 'Jun 26 1991 12:00:00:000AM', 107, 5300.00 )

go

insert into EMPLOYEE values ( 184, 105, 'White', 'Curits', '415-320-6492',
 '175 Kristen St.', 'Belmont', 'CA', '94180', 9,
 'Jan 25 1989 12:00:00:000AM', 101, 5000.00 )

go

insert into EMPLOYEE values ( 185, 420,'Yee', 'Peggy', '415-328-1314',
 '4885 France Ave.', 'Half Moon Bay', 'CA', '94239', 4,
 'Aug 16 1990 12:00:00:000AM', 103, 4600.00 )

go

insert into EMPLOYEE values ( 186, 900, 'Derrickson', 'Joy', '415-327-5048',
 '5708 Elm Ave.', 'Redwood City', 'CA', '94231', 12,
 'Aug 15 1988 12:00:00:000AM', 109, 4700.00 )

go

insert into EMPLOYEE values ( 187, 330, 'Steenkamer', 'Jerry', '415-324-4072',
 '3861 Washington St.', 'San Jose', 'CA', '94238', 4,
 'Oct  6 1991 12:00:00:000AM', 107, 5200.00 )

go

insert into EMPLOYEE values ( 188, 252, 'Sridhara', 'Dieter', '415-321-5690',
 '3025 Lancaster Blvd.', 'Atherton', 'CA', '94233', 5,
 'Jun  7 1988 12:00:00:000AM', 102, 4900.00 )

go

insert into EMPLOYEE values ( 189, 100, 'Mikkelsen', 'Rob', '415-321-6689',
 '4027 Shorebird Ave.', 'Woodside', 'CA', '94188', 9,
 'May 12 1991 12:00:00:000AM', 101, 4400.00 )

go

insert into EMPLOYEE values ( 190, 500,'Yee', 'Kollivakkam', '415-324-1358',
 '3271 Knuth St.', 'Palo Alto', 'CA', '94217', 4,
 'Jan 10 1988 12:00:00:000AM', 106, 4800.00 )

go


insert into EMPLOYEE values ( 191, 204, 'Guerrero', 'Stephen', '415-321-6736',
 '6368 Anderson St.', 'Palo Alto', 'CA', '94173', 5,
 'Jun  3 1992 12:00:00:000AM', 102, 4600.00 )

go

insert into EMPLOYEE values ( 192, 420, 'Page', 'Michael', '415-321-1199',
 '7713 Middlefield Ave.', 'Atherton', 'CA', '94194', 5,
 'Nov 23 1988 12:00:00:000AM', 103, 4500.00 )

go

insert into EMPLOYEE values ( 193, 350, 'McClung', 'Chad', '415-327-1329',
 '2902 Connell Ave.', 'Sunnyvale', 'CA', '94181', 7,
 'Aug 25 1988 12:00:00:000AM', 107, 4200.00 )

go

insert into EMPLOYEE values ( 194, 104, 'Perka', 'Sam', '415-326-1256',
 '61 Knox St.', 'Santa Clara', 'CA', '94191', 9,
 'Nov 23 1988 12:00:00:000AM', 101, 4900.00 )

go

insert into EMPLOYEE values ( 195, 420, 'Sickinghe', 'Sherman', '415-325-2233',
 '4865 France St.', 'Atherton', 'CA', '94207', 5,
 'Jul 19 1989 12:00:00:000AM', 103, 4500.00 )

go

insert into EMPLOYEE values ( 196, 250, 'Welch', 'Robin', '415-328-1833',
 '7631 Knox Road', 'Mountain View', 'CA', '94153', 5,
 'Oct 21 1991 12:00:00:000AM', 102, 4100.00 )

go

insert into EMPLOYEE values ( 197, 105, 'Nardin', 'Larry', '415-321-2064',
 '6179 Main St.', 'Tiberon', 'CA', '94157', 8,
 'Dec 13 1992 12:00:00:000AM', 101, 4600.00 )

go

insert into EMPLOYEE values ( 198, 100, 'Zamarripa', 'Drew', '415-320-2956',
 '6542 State St.', 'Pacific Heights', 'CA', '94163', 10,
 'Jul 18 1991 12:00:00:000AM', 101, 5400.00 )

go

insert into EMPLOYEE values ( 199, 500, 'Edwards', 'John', '415-328-186 ',
 '1318 Chowen St.', 'Mountain View', 'CA', '94198', 4,
 'Jun 12 1989 12:00:00:000AM', 106, 5100.00 )

go

insert into EMPLOYEE values ( 200, 202,'Schrey', 'Scott', '415-323-3258',
 '4033 Knox Road', 'Woodside', 'CA', '94206', 5,
 'Nov  2 1989 12:00:00:000AM', 102, 4000.00 )

go


insert into EMPLOYEE values ( 201, 320, 'Jackson', 'Mike', '415-323-8048',
 '6956 Spruce St.', 'Mountain View', 'CA', '94187', 10,
 'Apr 14 1992 12:00:00:000AM', 107, 4700.00 )

go

insert into EMPLOYEE values ( 202, 252, 'Mostofi', 'Richard', '415-324-3019',
 '1704 Lancaster Road', 'Palo Alto', 'CA', '94206', 5,
 'Aug 12 1989 12:00:00:000AM', 102, 4500.00 )

go

insert into EMPLOYEE values ( 203, 410, 'Bonidy', 'Salvatore', '415-322-582 ',
 '3116 Knuth Ave.', 'Half Moon Bay', 'CA', '94245', 5,
 'Apr 14 1992 12:00:00:000AM', 103, 5200.00 )

go

insert into EMPLOYEE values ( 204, 101, 'Janssen', 'Gene', '415-327-7614',
 '648 Washington Way', 'San Jose', 'CA', '94175', 8,
 'Apr 17 1988 12:00:00:000AM', 1, 4300.00 )

go

insert into EMPLOYEE values ( 205, 252,'Scott', 'Ken', '415-325-3118',
 '5936 Strand Road', 'Palo Alto', 'CA', '94150', 5,
 'Jul 13 1989 12:00:00:000AM', 102, 5700.00 )

go

insert into EMPLOYEE values ( 206, 101, 'Droulers', 'Matt', '415-322-213 ',
 '4617 Roberts Blvd.', 'Sunnyvale', 'CA', '94232', 7,
 'Nov 23 1990 12:00:00:000AM', 101, 4400.00 )

go

insert into EMPLOYEE values ( 207, 202, 'Pinkerton', 'Matt', '415-324-6350',
 '7803 Sparrow Road', 'Woodside', 'CA', '94245', 4,
 'Jul  6 1991 12:00:00:000AM', 102, 5600.00 )

go

insert into EMPLOYEE values ( 208, 202, 'Campetelli', 'Margaret', '415-321-2664',
 '7435 Strand Blvd.', 'Redwood City', 'CA', '94200', 5,
 'Sep 19 1992 12:00:00:000AM', 102, 5200.00 )

go

insert into EMPLOYEE values ( 209, 410, 'Lee', 'Jerry', '415-325-9499',
 '1484 Adams St.', 'Tiberon', 'CA', '94191', 5,
 'Jan 11 1991 12:00:00:000AM', 103, 5000.00 )

go

insert into EMPLOYEE values ( 210, 250,'Bucher', 'Fred', '415-323-8440',
 '7048 Knox Road', 'Palo Alto', 'CA', '94243', 3,
 'May 18 1988 12:00:00:000AM', 102, 4000.00 )

go


insert into EMPLOYEE values ( 211, 400, 'Farah', 'David', '415-322-2744',
 '1691 Pelican St.', 'San Francisco', 'CA', '94242', 5,
 'Mar 17 1988 12:00:00:000AM', 103, 4600.00 )

go

insert into EMPLOYEE values ( 212, 350, 'Avenell', 'Perry', '415-328-1319',
 '5910 Lutece Road', 'Palo Alto', 'CA', '94172', 7,
 'May  9 1992 12:00:00:000AM', 107, 5500.00 )

go

insert into EMPLOYEE values ( 213, 200, 'Butler', 'Mike', '415-327-8235',
 '5872 Regent Ave.', 'Palo Alto', 'CA', '94226', 11,
 'May  5 1990 12:00:00:000AM', 102, 5400.00 )

go

insert into EMPLOYEE values ( 214, 405, 'Graves', 'David', '415-323-6928',
 '5706 Shorebird Road', 'Sunnyvale', 'CA', '94173', 5,
 'Nov 14 1992 12:00:00:000AM', 103, 4100.00 )

go

insert into EMPLOYEE values ( 215, 350,'Hourvitz', 'Keith', '415-326-7210',
 '1092 Pelican St.', 'Sunnyvale', 'CA', '94185', 7,
 'Mar  6 1989 12:00:00:000AM', 107, 5400.00 )

go

insert into EMPLOYEE values ( 216, 105, 'Messer', 'Tushar', '415-322-2698',
 '7117 Drew Road', 'Tiberon', 'CA', '94201', 3,
 'Feb 21 1990 12:00:00:000AM', 101, 4800.00 )

go

insert into EMPLOYEE values ( 217, 101, 'Bumgarner', 'Kristen', '415-321-2840',
 '2039 Adams St.', 'Belmont', 'CA', '94174', 9,
 'Apr 17 1988 12:00:00:000AM', 101, 5600.00 )

go

insert into EMPLOYEE values ( 218, 201, 'Derrickson', 'Ben', '415-322-5122',
 '513 Connell St.', 'Tiberon', 'CA', '94176', 6,
 'Aug 15 1988 12:00:00:000AM', 102, 4900.00 )

go

insert into EMPLOYEE values ( 219, 101, 'Rushin', 'Mark', '415-323-5883',
 '5391 Addams St.', 'Redwood City', 'CA', '94221', 6,
 'Oct 14 1989 12:00:00:000AM', 101, 4900.00 )

go

insert into EMPLOYEE values ( 220, 100,'Graffagnino', 'Susan', '415-323-3617',
 '5999 Walnut Circle', 'Tiberon', 'CA', '94239', 7,
 'Jan  6 1992 12:00:00:000AM', 101, 4400.00 )

go


insert into EMPLOYEE values ( 221, 202, 'Gibbons', 'Jim', '415-326-9370',
 '2305 Emerson St.', 'Millbrae', 'CA', '94188', 4,
 'Nov 13 1988 12:00:00:000AM', 102, 4700.00 )

go

insert into EMPLOYEE values ( 222, 101, 'Wasmeier', 'Ken', '415-326-6257',
 '7802 Schoman St.', 'Atherton', 'CA', '94159', 8,
 'Nov  5 1990 12:00:00:000AM', 101, 5300.00 )

go

insert into EMPLOYEE values ( 223, 405, 'Joseph', 'Ralph', '415-325-6536',
 '3635 France St.', 'San Jose', 'CA', '94199', 5,
 'May 15 1989 12:00:00:000AM', 103, 4100.00 )

go

insert into EMPLOYEE values ( 224, 201, 'Fried', 'Joel', '415-320-9111',
 '1493 Roberts St.', 'Palo Alto', 'CA', '94196', 6,
 'Apr  2 1989 12:00:00:000AM', 102, 5200.00 )

go

insert into EMPLOYEE values ( 225, 410,'Blumenfeld', 'Linda', '415-321-2818',
 '4373 Roberts St.', 'Mountain View', 'CA', '94195', 5,
 'Jun 11 1991 12:00:00:000AM', 103, 5700.00 )

go

insert into EMP_PHOTO(EMP_ID) values (101)
insert into EMP_PHOTO(EMP_ID) values (102)
insert into EMP_PHOTO(EMP_ID) values (103)
insert into EMP_PHOTO(EMP_ID) values (104)
insert into EMP_PHOTO(EMP_ID) values (105)
insert into EMP_PHOTO(EMP_ID) values (106)
insert into EMP_PHOTO(EMP_ID) values (107)
insert into EMP_PHOTO(EMP_ID) values (108)
insert into EMP_PHOTO(EMP_ID) values (109)
insert into EMP_PHOTO(EMP_ID) values (110)
insert into EMP_PHOTO(EMP_ID) values (111)
insert into EMP_PHOTO(EMP_ID) values (112)
insert into EMP_PHOTO(EMP_ID) values (113)
insert into EMP_PHOTO(EMP_ID) values (114)
insert into EMP_PHOTO(EMP_ID) values (115)
insert into EMP_PHOTO(EMP_ID) values (116)
insert into EMP_PHOTO(EMP_ID) values (117)
insert into EMP_PHOTO(EMP_ID) values (118)
insert into EMP_PHOTO(EMP_ID) values (119)
insert into EMP_PHOTO(EMP_ID) values (120)
insert into EMP_PHOTO(EMP_ID) values (121)
insert into EMP_PHOTO(EMP_ID) values (122)
insert into EMP_PHOTO(EMP_ID) values (123)
insert into EMP_PHOTO(EMP_ID) values (124)
insert into EMP_PHOTO(EMP_ID) values (125)
insert into EMP_PHOTO(EMP_ID) values (126)
insert into EMP_PHOTO(EMP_ID) values (127)
insert into EMP_PHOTO(EMP_ID) values (128)
insert into EMP_PHOTO(EMP_ID) values (129)
insert into EMP_PHOTO(EMP_ID) values (130)
insert into EMP_PHOTO(EMP_ID) values (131)
insert into EMP_PHOTO(EMP_ID) values (132)
insert into EMP_PHOTO(EMP_ID) values (133)
insert into EMP_PHOTO(EMP_ID) values (134)
insert into EMP_PHOTO(EMP_ID) values (135)
insert into EMP_PHOTO(EMP_ID) values (136)
insert into EMP_PHOTO(EMP_ID) values (137)
insert into EMP_PHOTO(EMP_ID) values (138)
insert into EMP_PHOTO(EMP_ID) values (139)
insert into EMP_PHOTO(EMP_ID) values (140)
insert into EMP_PHOTO(EMP_ID) values (141)
insert into EMP_PHOTO(EMP_ID) values (142)
insert into EMP_PHOTO(EMP_ID) values (143)
insert into EMP_PHOTO(EMP_ID) values (144)
insert into EMP_PHOTO(EMP_ID) values (145)
insert into EMP_PHOTO(EMP_ID) values (146)
insert into EMP_PHOTO(EMP_ID) values (147)
insert into EMP_PHOTO(EMP_ID) values (148)
insert into EMP_PHOTO(EMP_ID) values (149)
insert into EMP_PHOTO(EMP_ID) values (150)
insert into EMP_PHOTO(EMP_ID) values (151)
insert into EMP_PHOTO(EMP_ID) values (152)
insert into EMP_PHOTO(EMP_ID) values (153)
insert into EMP_PHOTO(EMP_ID) values (154)
insert into EMP_PHOTO(EMP_ID) values (155)
insert into EMP_PHOTO(EMP_ID) values (156)
insert into EMP_PHOTO(EMP_ID) values (157)
insert into EMP_PHOTO(EMP_ID) values (158)
insert into EMP_PHOTO(EMP_ID) values (159)
insert into EMP_PHOTO(EMP_ID) values (160)
insert into EMP_PHOTO(EMP_ID) values (161)
insert into EMP_PHOTO(EMP_ID) values (162)
insert into EMP_PHOTO(EMP_ID) values (163)
insert into EMP_PHOTO(EMP_ID) values (164)
insert into EMP_PHOTO(EMP_ID) values (165)
insert into EMP_PHOTO(EMP_ID) values (166)
insert into EMP_PHOTO(EMP_ID) values (167)
insert into EMP_PHOTO(EMP_ID) values (168)
insert into EMP_PHOTO(EMP_ID) values (169)
insert into EMP_PHOTO(EMP_ID) values (170)
insert into EMP_PHOTO(EMP_ID) values (171)
insert into EMP_PHOTO(EMP_ID) values (172)
insert into EMP_PHOTO(EMP_ID) values (173)
insert into EMP_PHOTO(EMP_ID) values (174)
insert into EMP_PHOTO(EMP_ID) values (175)
insert into EMP_PHOTO(EMP_ID) values (176)
insert into EMP_PHOTO(EMP_ID) values (177)
insert into EMP_PHOTO(EMP_ID) values (178)
insert into EMP_PHOTO(EMP_ID) values (179)
insert into EMP_PHOTO(EMP_ID) values (180)
insert into EMP_PHOTO(EMP_ID) values (181)
insert into EMP_PHOTO(EMP_ID) values (182)
insert into EMP_PHOTO(EMP_ID) values (183)
insert into EMP_PHOTO(EMP_ID) values (184)
insert into EMP_PHOTO(EMP_ID) values (185)
insert into EMP_PHOTO(EMP_ID) values (186)
insert into EMP_PHOTO(EMP_ID) values (187)
insert into EMP_PHOTO(EMP_ID) values (188)
insert into EMP_PHOTO(EMP_ID) values (189)
insert into EMP_PHOTO(EMP_ID) values (190)
insert into EMP_PHOTO(EMP_ID) values (191)
insert into EMP_PHOTO(EMP_ID) values (192)
insert into EMP_PHOTO(EMP_ID) values (193)
insert into EMP_PHOTO(EMP_ID) values (194)
insert into EMP_PHOTO(EMP_ID) values (195)
insert into EMP_PHOTO(EMP_ID) values (196)
insert into EMP_PHOTO(EMP_ID) values (197)
insert into EMP_PHOTO(EMP_ID) values (198)
insert into EMP_PHOTO(EMP_ID) values (199)
insert into EMP_PHOTO(EMP_ID) values (200)
insert into EMP_PHOTO(EMP_ID) values (201)
insert into EMP_PHOTO(EMP_ID) values (202)
insert into EMP_PHOTO(EMP_ID) values (203)
insert into EMP_PHOTO(EMP_ID) values (204)
insert into EMP_PHOTO(EMP_ID) values (205)
insert into EMP_PHOTO(EMP_ID) values (206)
insert into EMP_PHOTO(EMP_ID) values (207)
insert into EMP_PHOTO(EMP_ID) values (208)
insert into EMP_PHOTO(EMP_ID) values (209)
insert into EMP_PHOTO(EMP_ID) values (210)
insert into EMP_PHOTO(EMP_ID) values (211)
insert into EMP_PHOTO(EMP_ID) values (212)
insert into EMP_PHOTO(EMP_ID) values (213)
insert into EMP_PHOTO(EMP_ID) values (214)
insert into EMP_PHOTO(EMP_ID) values (215)
insert into EMP_PHOTO(EMP_ID) values (216)
insert into EMP_PHOTO(EMP_ID) values (217)
insert into EMP_PHOTO(EMP_ID) values (218)
insert into EMP_PHOTO(EMP_ID) values (219)
insert into EMP_PHOTO(EMP_ID) values (220)
insert into EMP_PHOTO(EMP_ID) values (221)
insert into EMP_PHOTO(EMP_ID) values (222)
insert into EMP_PHOTO(EMP_ID) values (223)
insert into EMP_PHOTO(EMP_ID) values (224)
insert into EMP_PHOTO(EMP_ID) values (225)
go




insert into EMP_EQUIPMENT values (1100, 'NeXTstation 8/105', '984-9749', 119)
go

insert into EMP_EQUIPMENT values (1101, 'NeXTstation 8/105', '929-22249', 149)
go

insert into EMP_EQUIPMENT values (1102, 'NeXTstation Color 8/105', '397-40272', 166)
go

insert into EMP_EQUIPMENT values (1103, 'NeXTstation Color 16/200', '233-86445', 127)
go

insert into EMP_EQUIPMENT values (1104, 'NeXTstation 16/400', '207-53910', 131)
go

insert into EMP_EQUIPMENT values (1105, 'NeXTstation  Color Turbo 16/200', '508-67548', 147)
go

insert into EMP_EQUIPMENT values (1106, 'NeXTstation 16/200', '436-80755', 161)
go

insert into EMP_EQUIPMENT values (1107, 'NeXTstation  Color Turbo 16/200', '543-37393', 156)
go

insert into EMP_EQUIPMENT values (1108, 'NeXTstation 16/200', '547-30645', 218)
go

insert into EMP_EQUIPMENT values (1109, 'NeXTstation 8/105', '476-93085', 178)
go

insert into EMP_EQUIPMENT values (1110, 'NeXTDimension', '336-24689', 137)
go

insert into EMP_EQUIPMENT values (1111, 'NeXTstation Turbo 16/400', '549-35596', 193)
go

insert into EMP_EQUIPMENT values (1112, 'NeXTstation Color 8/105', '26-33143', 144)
go

insert into EMP_EQUIPMENT values (1113, 'NeXTstation  Color Turbo 8/105', '393-60933', 164)
go

insert into EMP_EQUIPMENT values (1114, 'NeXTstation Color 8/105', '748-91478', 184)
go

insert into EMP_EQUIPMENT values (1115, 'NeXTDimension', '754-23106', 140)
go

insert into EMP_EQUIPMENT values (1116, 'NeXTstation  Color Turbo 16/400', '372-28680', 152)
go

insert into EMP_EQUIPMENT values (1117, 'NeXTstation Color 16/400', '13-44241', 211)
go

insert into EMP_EQUIPMENT values (1118, 'NeXTstation  Color Turbo 16/200', '539-51330', 214)
go

insert into EMP_EQUIPMENT values (1119, 'NeXTstation Color 16/200', '418-68918', 103)
go

insert into EMP_EQUIPMENT values (1120, 'NeXTstation 16/200', '809-46727', 143)
go

insert into EMP_EQUIPMENT values (1121, 'NeXTstation 8/105', '279-2385', 118)
go

insert into EMP_EQUIPMENT values (1122, 'NeXTstation  Color Turbo 16/200', '414-69939', 179)
go

insert into EMP_EQUIPMENT values (1123, 'NeXTstation  Color Turbo 16/200', '796-69543', 188)
go

insert into EMP_EQUIPMENT values (1124, 'NeXTstation  Color Turbo 16/200', '537-89239', 154)
go

insert into EMP_EQUIPMENT values (1125, 'NeXTstation 16/400', '541-23964', 198)
go

insert into EMP_EQUIPMENT values (1126, 'NeXTstation Turbo 16/400', '178-21075', 113)
go

insert into EMP_EQUIPMENT values (1127, 'NeXTstation 16/200', '243-74685', 183)
go

insert into EMP_EQUIPMENT values (1128, 'NeXTstation 16/400', '702-51108', 138)
go

insert into EMP_EQUIPMENT values (1129, 'NeXTstation 16/200', '193-79563', 171)
go

insert into EMP_EQUIPMENT values (1130, 'NeXTstation Color 16/200', '595-86545', 160)
go

insert into EMP_EQUIPMENT values (1131, 'NeXTstation Color 16/200', '226-22739', 210)
go

insert into EMP_EQUIPMENT values (1132, 'NeXTstation Turbo 16/400', '98-6934', 204)
go

insert into EMP_EQUIPMENT values (1133, 'NeXTstation 16/400', '513-28929', 134)
go

insert into EMP_EQUIPMENT values (1134, 'NeXTstation 8/105', '349-4738', 163)
go

insert into EMP_EQUIPMENT values (1135, 'NeXTstation  Color Turbo 16/200', '941-66087', 132)
go

insert into EMP_EQUIPMENT values (1136, 'NeXTstation Color 16/400', '382-65389', 114)
go

insert into EMP_EQUIPMENT values (1137, 'NeXTstation 16/400', '664-62232', 117)
go

insert into EMP_EQUIPMENT values (1138, 'NeXTstation Color 8/105', '5-36913', 136)
go

insert into EMP_EQUIPMENT values (1139, 'NeXTstation Color 16/400', '370-90496', 153)
go

insert into EMP_EQUIPMENT values (1140, 'NeXTDimension', '984-7872', 169)
go

insert into EMP_EQUIPMENT values (1141, 'NeXTstation Color 16/400', '277-34231', 145)
go

insert into EMP_EQUIPMENT values (1142, 'NeXTstation 16/400', '753-51711', 150)
go

insert into EMP_EQUIPMENT values (1143, 'NeXTstation  Color Turbo 8/105', '123-7629', 155)
go

insert into EMP_EQUIPMENT values (1144, 'NeXTstation 16/400', '800-3038', 124)
go

insert into EMP_EQUIPMENT values (1145, 'NeXTstation Color 8/105', '486-77628', 180)
go

insert into EMP_EQUIPMENT values (1146, 'NeXTstation 8/105', '824-13576', 187)
go

insert into EMP_EQUIPMENT values (1147, 'NeXTstation Color 8/105', '626-42240', 209)
go

insert into EMP_EQUIPMENT values (1148, 'NeXTstation  Color Turbo 8/105', '781-27064', 129)
go

insert into EMP_EQUIPMENT values (1149, 'NeXTstation  Color Turbo 16/200', '914-13130', 162)
go

insert into EMP_EQUIPMENT values (1150, 'NeXTstation Turbo 16/400', '95-49295', 174)
go

insert into EMP_EQUIPMENT values (1151, 'NeXTstation Color 8/105', '647-96907', 221)
go

insert into EMP_EQUIPMENT values (1152, 'NeXTDimension', '117-87463', 224)
go

insert into EMP_EQUIPMENT values (1153, 'NeXTstation  Color Turbo 16/200', '670-29606', 106)
go

insert into EMP_EQUIPMENT values (1154, 'NeXTstation 16/400', '332-52077', 148)
go

insert into EMP_EQUIPMENT values (1155, 'NeXTstation Color 16/200', '852-63799', 199)
go

insert into EMP_EQUIPMENT values (1156, 'NeXTstation Color 8/105', '440-37613', 115)
go

insert into EMP_EQUIPMENT values (1157, 'NeXTstation  Color Turbo 16/400', '298-58959', 122)
go

insert into EMP_EQUIPMENT values (1158, 'NeXTstation  Color Turbo 8/105', '164-40348', 165)
go

insert into EMP_EQUIPMENT values (1159, 'NeXTstation  Color Turbo 8/105', '975-497', 151)
go

insert into EMP_EQUIPMENT values (1160, 'NeXTstation Color 16/200', '741-12300', 186)
go

insert into EMP_EQUIPMENT values (1161, 'NeXTstation 8/105', '126-40700', 135)
go

insert into EMP_EQUIPMENT values (1162, 'NeXTstation 16/200', '923-50658', 102)
go

insert into EMP_EQUIPMENT values (1163, 'NeXTstation  Color Turbo 16/200', '705-40124', 105)
go

insert into EMP_EQUIPMENT values (1164, 'NeXTstation Color 16/400', '985-27011', 128)
go

insert into EMP_EQUIPMENT values (1165, 'NeXTstation 16/400', '83-84294', 142)
go

insert into EMP_EQUIPMENT values (1166, 'NeXTstation 16/400', '233-32050', 215)
go

insert into EMP_EQUIPMENT values (1167, 'NeXTstation 16/400', '226-34036', 107)
go

insert into EMP_EQUIPMENT values (1168, 'NeXTDimension', '524-60536', 176)
go

insert into EMP_EQUIPMENT values (1169, 'NeXTstation 8/105', '104-65265', 205)
go

insert into EMP_EQUIPMENT values (1170, 'NeXTstation  Color Turbo 16/400', '794-54450', 222)
go

insert into EMP_EQUIPMENT values (1171, 'NeXTstation Color 16/200', '550-87024', 190)
go

insert into EMP_EQUIPMENT values (1172, 'NeXTstation 16/200', '75-57330', 175)
go

insert into EMP_EQUIPMENT values (1173, 'NeXTstation 16/200', '709-24372', 217)
go

insert into EMP_EQUIPMENT values (1174, 'NeXTstation  Color Turbo 16/200', '388-38271', 173)
go

insert into EMP_EQUIPMENT values (1175, 'NeXTstation 8/105', '98-76041', 197)
go

insert into EMP_EQUIPMENT values (1176, 'NeXTstation  Color Turbo 8/105', '767-36932', 158)
go

insert into EMP_EQUIPMENT values (1177, 'NeXTstation 8/105', '595-13623', 139)
go

insert into EMP_EQUIPMENT values (1178, 'NeXTstation 8/105', '664-82207', 104)
go

insert into EMP_EQUIPMENT values (1179, 'NeXTDimension', '830-38108', 225)
go

insert into EMP_EQUIPMENT values (1180, 'NeXTstation Color 16/200', '281-5023', 141)
go

insert into EMP_EQUIPMENT values (1181, 'NeXTstation  Color Turbo 16/200', '388-51896', 208)
go

insert into EMP_EQUIPMENT values (1182, 'NeXTDimension', '813-75150', 109)
go

insert into EMP_EQUIPMENT values (1183, 'NeXTstation Color 8/105', '576-43283', 112)
go

insert into EMP_EQUIPMENT values (1184, 'NeXTstation 16/200', '563-21410', 146)
go

insert into EMP_EQUIPMENT values (1185, 'NeXTstation Color 8/105', '384-26683', 219)
go

insert into EMP_EQUIPMENT values (1186, 'NeXTDimension', '449-97816', 157)
go

insert into EMP_EQUIPMENT values (1187, 'NeXTstation 8/105', '853-64862', 206)
go

insert into EMP_EQUIPMENT values (1188, 'NeXTstation 8/105', '621-8809', 207)
go

insert into EMP_EQUIPMENT values (1189, 'NeXTstation 16/200', '162-25658', 111)
go

insert into EMP_EQUIPMENT values (1190, 'NeXTstation Color 8/105', '621-29151', 120)
go

insert into EMP_EQUIPMENT values (1191, 'NeXTstation  Color Turbo 16/400', '63-38117', 192)
go

insert into EMP_EQUIPMENT values (1192, 'NeXTstation  Color Turbo 16/200', '704-39748', 181)
go

insert into EMP_EQUIPMENT values (1193, 'NeXTstation 8/105', '785-84375', 201)
go

insert into EMP_EQUIPMENT values (1194, 'NeXTstation Color 16/400', '652-37816', 213)
go

insert into EMP_EQUIPMENT values (1195, 'NeXTstation Color 16/200', '886-84102', 172)
go

insert into EMP_EQUIPMENT values (1196, 'NeXTstation  Color Turbo 16/200', '831-87177', 108)
go

insert into EMP_EQUIPMENT values (1197, 'NeXTstation  Color Turbo 16/200', '739-26210', 177)
go

insert into EMP_EQUIPMENT values (1198, 'NeXTstation 16/200', '396-71735', 125)
go

insert into EMP_EQUIPMENT values (1199, 'NeXTstation 16/400', '34-79809', 126)
go

insert into EMP_EQUIPMENT values (1200, 'NeXTstation Color 8/105', '334-59161', 185)
go

insert into EMP_EQUIPMENT values (1201, 'NeXTDimension', '524-41124', 212)
go

insert into EMP_EQUIPMENT values (1202, 'NeXTstation Color 8/105', '836-89146', 110)
go

insert into EMP_EQUIPMENT values (1203, 'NeXTstation Color 16/400', '608-57474', 223)
go

insert into EMP_EQUIPMENT values (1204, 'NeXTstation  Color Turbo 16/200', '722-85049', 202)
go

insert into EMP_EQUIPMENT values (1205, 'NeXTstation  Color Turbo 16/400', '532-78167', 189)
go

insert into EMP_EQUIPMENT values (1206, 'NeXTstation Turbo 16/400', '16-926', 196)
go

insert into EMP_EQUIPMENT values (1207, 'NeXTstation Turbo 16/400', '518-18514', 133)
go

insert into EMP_EQUIPMENT values (1208, 'NeXTDimension', '384-72591', 167)
go

insert into EMP_EQUIPMENT values (1209, 'NeXTDimension', '334-21983', 203)
go

insert into EMP_EQUIPMENT values (1210, 'NeXTstation  Color Turbo 16/200', '391-49812', 194)
go

insert into EMP_EQUIPMENT values (1211, 'NeXTstation Turbo 16/400', '6-87480', 121)
go

insert into EMP_EQUIPMENT values (1212, 'NeXTstation  Color Turbo 16/200', '197-13972', 130)
go

insert into EMP_EQUIPMENT values (1213, 'NeXTstation Color 16/400', '33-39584', 200)
go

insert into EMP_EQUIPMENT values (1214, 'NeXTstation Color 16/200', '992-3848', 195)
go

insert into EMP_EQUIPMENT values (1215, 'NeXTstation  Color Turbo 8/105', '277-10448', 101)
go

insert into EMP_EQUIPMENT values (1216, 'NeXTstation  Color Turbo 16/400', '975-77088', 191)
go

insert into EMP_EQUIPMENT values (1217, 'NeXTstation Turbo 16/400', '294-32339', 220)
go

insert into EMP_EQUIPMENT values (1218, 'NeXTDimension', '618-27833', 182)
go

insert into EMP_EQUIPMENT values (1219, 'NeXTstation 16/400', '103-83650', 123)
go

insert into EMP_EQUIPMENT values (1220, 'NeXTstation  Color Turbo 16/200', '756-14950', 170)
go

insert into EMP_EQUIPMENT values (1221, 'NeXTstation 16/400', '436-91312', 216)
go

insert into EMP_EQUIPMENT values (1222, 'NeXTstation  Color Turbo 16/200', '489-13117', 159)
go

insert into EMP_EQUIPMENT values (1223, 'NeXTstation  Color Turbo 8/105', '579-12221', 168)
go

insert into EMP_EQUIPMENT values (1224, 'NeXTstation 16/400', '551-13204', 116)
go

insert into EMP_QUOTE(EMP_ID) select EMP_ID from EMPLOYEE
go

commit transaction
go


/******************************************************************************
*  Create table indexes.
******************************************************************************/
create unique INDEX EMP_INDEX1 on EMPLOYEE(EMP_ID)
go

create unique INDEX DEPT_INDEX1 on DEPARTMENT(DEPT_ID)
go

create unique INDEX FACILITY_INDEX1 on FACILITY(LOCATION_ID)
go

create unique INDEX EMPPROJ_INDEX1 on EMP_PROJECT(EMP_ID,PROJECT_ID)
go

create unique INDEX PROJ_INDEX1 on PROJECT(PROJECT_ID)
go

create unique INDEX EMP_PHOTO_INDEX1 on EMP_PHOTO(EMP_ID)
go

create unique INDEX EMP_QUOTE_INDEX1 on EMP_QUOTE(EMP_ID)
go

create unique INDEX JOB_TITLE_INDEX1 on JOB_TITLE(TITLE_ID)
go

create unique INDEX ASSET_INDEX1 on EMP_EQUIPMENT(ASSET_TAG)
go


/******************************************************************************
* Create the UNIQUE_KEY table, which stores the MAX_KEY for each ENTITY_NAME.
******************************************************************************/
create table UNIQUE_KEY (
ENTITY_NAME varchar(100),
MAX_KEY int
)
go

insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMPLOYEE',max(EMP_ID) from EMPLOYEE
go
insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'DEPARTMENT',max(DEPT_ID) from DEPARTMENT
go
insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'FACILITY',max(LOCATION_ID) from FACILITY
go
insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'PROJECT',max(PROJECT_ID) from PROJECT
go
insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'JOB_TITLE',max(TITLE_ID) from JOB_TITLE
go
insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMP_EQUIPMENT',max(ASSET_TAG) from EMP_EQUIPMENT
go

create unique INDEX UNIQUE_KEY_INDEX1 on UNIQUE_KEY(ENTITY_NAME)
go